package com.airy.highSpeed.dao.oracle;

import com.airy.highSpeed.entity.FlowTrafficEntity;
import com.airy.highSpeed.entity.RktxEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import java.util.Date;
import java.util.List;

/**
 * ${comments}
 *
 * @author dingyakun
 * @email 821041490@qq.com
 * @date 2020-12-15 13:21:16
 */
@Component
@Mapper
public interface FlowTrafficDao extends BaseMapper<FlowTrafficEntity> {

    List<FlowTrafficEntity> findAll();

    List<FlowTrafficEntity> find(@Param("shijian") String shijian, @Param("bianhao") String bianhao);

    List<FlowTrafficEntity> findBystartTimeAndTollStationIdAndFlage1(@Param("thisWeekDateLastOneWeek") String thisWeekDateLastOneWeek, @Param("thisWeekDateLastTwoWeek") String thisWeekDateLastTwoWeek, @Param("thisWeekDateLastThreeWeek") String thisWeekDateLastThreeWeek, @Param("thisWeekDateLastFourWeek") String thisWeekDateLastFourWeek, @Param("tollStationId") String tollStationId);

    List<FlowTrafficEntity> findBystartTimeAndTollStationIdAndFlage2(@Param("thisWeekDateLastOneWeek") String thisWeekDateLastOneWeek, @Param("thisWeekDateLastTwoWeek") String thisWeekDateLastTwoWeek, @Param("thisWeekDateLastThreeWeek") String thisWeekDateLastThreeWeek, @Param("thisWeekDateLastFourWeek") String thisWeekDateLastFourWeek, @Param("tollStationId") String tollStationId);

    List<FlowTrafficEntity> findBySTARTTIMEAndTOLLSTATIONID(@Param("startTime") String startTime, @Param("tollStationId") String tollStationId);
}
